SUPPORT / SAMPLES & SAS NOTES
Problem Note 59756: SAS® Federation Server Manager 4.2 is removing duplicate schema options when configuring data services
 |  |  |  |  |
When you use SAS Federation Server Manager to configure data services, duplicate SCHEMA options are being removed, as illustrated in the following example.
Driver connection string:
HOST=myhost;SERV=14512;LOCALE=en_us;DBQ=PUBLIC;SCHEMA=(DBQ=public;FEDSQL_OBJECTS=NO;);SCHEMA=(DBQ=formats;FEDSQL_OBJECTS=NO;);
Notice that the SCHEMA option is listed twice. This is correct and necessary. However, SAS Federation Server Manager generates and issues the following DDL (to SAS Federation Server):
CREATE DATA SERVICE "SPDS53" TYPE GENERIC CATALOG "SPDS53" DOMAIN "SPDS" REGISTER () VALIDATE YES {OPTIONS CONOPTS(DRIVER SPDS, ADD SERV 14512,
SCHEMA(ADD FEDSQL_OBJECTS NO, ADD DBQ formats), ADD LOCALE en_us, ADD HOST myhost, ADD DBQ PUBLIC)}
Notice that there is only one set of SCHEMA options in the list. The first set of SCHEMA options was removed.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Federation Server | Microsoft® Windows® for x64 | 4.2 | 4.2.1 | 9.4 TS1M3 | 9.4 TS1M4 |
| Linux for x64 | 4.2 | 4.2.1 | 9.4 TS1M3 | 9.4 TS1M4 | ||